package com.grq.mis.dao;

import com.grq.mis.entity.LoginRecord;
import org.beetl.sql.mapper.BaseMapper;
import org.beetl.sql.mapper.annotation.Sql;
import org.beetl.sql.mapper.annotation.SqlResource;
import org.springframework.stereotype.Repository;

/*
* 
* gen by beetlsql3 mapper 2021-11-21
*/
@SqlResource("loginRecord")
@Repository
public interface LoginRecordDao extends BaseMapper<LoginRecord> {

    @Sql("select count(*) from t_login_record")
    long allVisit();

    @Sql("select count(*) from t_login_record where DATE_FORMAT(login_time, '%Y-%m-%d') = ?")
    long todayVisit(String today);
}
